/*
 *  Copyright 2001-2004 The Apache Software Foundation
 *
 *  Licensed under the Apache License, Version 2.0 (the "License");
 *  you may not use this file except in compliance with the License.
 *  You may obtain a copy of the License at
 *
 *      http://www.apache.org/licenses/LICENSE-2.0
 *
 *  Unless required by applicable law or agreed to in writing, software
 *  distributed under the License is distributed on an "AS IS" BASIS,
 *  WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
 *  See the License for the specific language governing permissions and
 *  limitations under the License.
 */
package ar.uba.fi.posgrado.common.dao.impl;

import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;

import org.hibernate.Criteria;
import org.hibernate.HibernateException;
import org.hibernate.Session;
import org.hibernate.criterion.Expression;
import org.hibernate.criterion.MatchMode;
import org.springframework.dao.DataAccessException;
import org.springframework.orm.ObjectRetrievalFailureException;
import org.springframework.orm.hibernate3.HibernateCallback;

import ar.uba.fi.posgrado.common.dao.AbstractDAO;
import ar.uba.fi.posgrado.common.dao.DAOException;
import ar.uba.fi.posgrado.common.dao.NoSuchEntityException;
import ar.uba.fi.posgrado.common.dao.StudentDAO;
import ar.uba.fi.posgrado.common.model.Student;

/**
 * Implementacion de {@linkplain StudentDAO student DAO}
 * 
 * @author pablo.tortorella
 * @author lautaro.gutierrez
 * @see AbstractDAO
 * @see StudentDAO
 */
public class StudentDAOImpl extends AbstractDAO<Student> implements StudentDAO {

	/**
	 * @see ar.uba.fi.posgrado.common.dao.AbstractDAO#getClazz()
	 */
	@SuppressWarnings("unchecked")
	protected Class getClazz() {
		return Student.class;
	}

	public Student findByPersonalId(final String personalId)
			throws NoSuchEntityException, DAOException {
		Student response = null;

		try {
			response = (Student) this.getHibernateTemplate().execute(
					new HibernateCallback() {
						public Object doInHibernate(Session session)
								throws HibernateException, SQLException {
							Criteria criteria = session
									.createCriteria(Student.class);
							criteria.add(Expression
									.eq("personalId", personalId));
							return criteria.uniqueResult();
						}
					});
			if (response == null) {
				// Necesario ya q el criteria no falla al no encontrar
				throw new NoSuchEntityException("No existe intancia de Alumno"
						+ ", con documento: " + personalId);
			}
		} catch (ObjectRetrievalFailureException e) {
			throw new NoSuchEntityException("No existe intancia de Alumno"
					+ ", con documento: " + personalId, e);
		} catch (DataAccessException e) {
			throw new DAOException(
					"Excepcion al buscar una intancia de Alumno "
							+ ", con documento: " + personalId + ". Mensaje: "
							+ e.getMessage(), e);
		}
		return response;
	}

	/**
	 * @see ar.uba.fi.posgrado.common.dao.StudentDAO#findBySurname(java.lang.String)
	 */
	@SuppressWarnings("unchecked")
	public List<Student> findBySurname(final String surname)
			throws NoSuchEntityException, DAOException {
		List<Student> response = null;

		try {
			response = (List) this.getHibernateTemplate().execute(
					new HibernateCallback() {
						public Object doInHibernate(Session session)
								throws HibernateException, SQLException {
							Criteria criteria = session
									.createCriteria(Student.class);
							criteria.add(Expression.ilike("surname", surname,
									MatchMode.ANYWHERE));
							return criteria.list();
						}
					});
			if (response == null) {
				response = new ArrayList<Student>();
			}
		} catch (DataAccessException e) {
			throw new DAOException("Excepcion al buscar alumnos con apellido: "
					+ surname + ". Mensaje: " + e.getMessage(), e);
		}

		return response;
	}

}
